{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Needs Chart","Life Chart Worksheet","Life Chart","Needs Chart Calculator"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Needs Chart","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[4,11,5,12],[4,1,4,5],[4,6,4,8],[27,1,27,4],[27,5,27,8],[21,1,21,4],[21,5,21,8],[22,1,22,4],[22,5,22,8],[23,1,23,4],[23,5,23,8],[18,1,18,4],[18,5,18,8],[19,1,19,4],[19,5,19,8],[20,1,20,4],[29,1,34,8],[36,1,36,2],[36,3,36,6],[36,7,36,8],[24,1,24,4],[24,5,24,8],[25,1,25,4],[25,5,25,8],[26,1,26,4],[26,5,26,8],[20,5,20,8],[15,1,15,4],[15,5,15,8],[16,1,16,4],[16,5,16,8],[17,1,17,4],[17,5,17,8],[12,1,12,4],[12,5,12,8],[13,1,13,4],[13,5,13,8],[14,1,14,4],[14,5,14,8],[9,1,9,4],[9,5,9,8],[10,1,10,4],[10,5,10,8],[11,1,11,4],[11,5,11,8],[3,1,3,8],[6,1,6,4],[6,5,6,8],[8,1,8,4],[8,5,8,8]]}
[]
[]
[]
[null,"Insurance to Income Ratio Chart*"]
[null,"HOW MUCH LIFE INSURANCE IS ENOUGH?",null,null,null,null,{"$f":"'Life Chart Worksheet'!C7","v":"Mr. Joe Client"},null,null,null,null,"(check box hides/unhides the \"Total Life Insurance\" amounts)"]
[]
[null,"Total Life Insurance",null,null,null,"Monthly Income"]
[]
[null,100000,null,null,null,400]
[null,200000,null,null,null,850]
[null,250000,null,null,null,1000]
[null,300000,null,null,null,1300]
[null,350000,null,null,null,1500]
[null,400000,null,null,null,1700]
[null,450000,null,null,null,1900]
[null,500000,null,null,null,2100]
[null,550000,null,null,null,2300]
[null,600000,null,null,null,2550]
[null,650000,null,null,null,2750]
[null,700000,null,null,null,3000]
[null,800000,null,null,null,3400]
[null,900000,null,null,null,3800]
[null,1000000,null,null,null,4250]
[null,1500000,null,null,null,6370]
[null,2000000,null,null,null,8500]
[null,3000000,null,null,null,12500]
[null,5000000,null,null,null,21250]
[null,10000000,null,null,null,42500]
[]
[null,"* This chart illustrates a potential monthly income, provided the initial capital amount is not used. It calculates the approximate amount of monthly net after-tax income that an insurance policy face amount (or capital amount) would provide to a surviving spouse per thirty-day period. It assumes 1) investing the total amount of insurance proceeds, 2) averaging a 6% investment yield, with 3) an average 15% tax liability."]
[]
[]
[]
[]
[]
[]
[null,"Presented to:",null,"Mr. Joe Client",null,null,null,{"$f":"TODAY()","v":"2019-07-15"}]
[]
[null,null,null,null,null,null,null,null,"12/2018mlm"]
[]
[]
["Sheet Protection Password - \"LIFE\""]
[]
[]
[null,"\""]

{"sheet":"Life Chart Worksheet","index":1,"n_rows":35,"n_cols":23,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,14,1,23],[21,22,22,23],[17,18,17,19],[21,16,22,17],[21,18,22,19],[21,20,22,21],[19,20,19,21],[19,22,19,23],[4,20,4,21],[20,22,20,23],[17,20,17,21],[17,22,17,23],[18,18,18,19],[18,20,18,21],[18,22,18,23],[15,18,15,19],[4,2,4,9],[1,1,1,9],[12,2,12,3],[2,2,2,8],[20,2,20,5],[15,2,15,3],[14,2,14,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[20,7,20,8],[13,7,13,9],[15,20,15,21],[15,22,15,23],[16,18,16,19],[16,20,16,21],[16,22,16,23],[9,16,9,17],[9,18,9,19],[9,20,9,21],[10,16,10,17],[10,18,10,19],[10,20,10,21],[11,16,11,17],[11,18,11,19],[11,20,11,21],[12,16,12,17],[12,18,12,19],[12,20,12,21],[13,18,13,19],[29,2,29,5],[29,6,30,6],[16,2,16,3],[17,2,17,3],[18,2,18,3],[29,13,29,23],[30,13,30,23],[23,16,23,19],[26,16,26,19],[20,20,20,21],[26,9,26,11],[23,2,23,5],[21,7,21,8],[31,22,31,24],[23,21,25,23],[8,16,8,17],[8,18,8,19],[8,20,8,21],[9,22,9,23],[10,22,10,23],[11,22,11,23],[12,22,12,23],[13,20,13,21],[13,22,13,23],[14,16,14,17],[14,18,14,19],[14,20,14,21],[14,22,14,23],[13,16,13,17]]}
[]
[null,"LAYERING INSURANCE FOR EFFECTIVENESS (L.I.F.E.)",null,null,null,null,null,null,null,null,null,null,null,null,"LAYERING INSURANCE FOR EFFECTIVENESS (L.I.F.E.)"]
[null,null,"The Professional Method for Balancing Life Protection Needs with Policy Costs",null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-15"}]
[]
[null,null,"Client Case Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-07-15"},"Client:   ",{"$f":"C7","v":"Mr. Joe Client"}]
[]
[null,"1-","Mr. Joe Client",null,"Client name?"]
[null,"2-",30,null,"Client age nearest birthday?"]
[null,"3-",6000,null,"Monthly income needed to sustain life for surviving dependent/s? (see Needs Chart)"]
[null,"4-","1 & 4",null,"Dependent children's ages?"]
[null,"5-",2019,null,"Initial year of coverage inception?"]
[null,"6-","next 20 years",null,"What are the 'critical years' (before dependents move out, income producing years, etc.)?"]
[null,"7-","INCOME, MTG",null,"Coverage uses: income replacement, pay off mortgage/debts, education, retirement, etc.?"]
[]
[null,null,"FACE AMOUNT",null,"POLICY TERM",null,"POLICY FACE","POLICY COST","ALL POLICIES","TERM"]
[null,"Pol 1",0,null,"10 Year Policy",null,{"$f":"C16","v":0},0,{"$f":"H16+H17+H18+H19","v":85.97},"for 10 yrs"]
[null,"Pol 2",0,null,"15 Year Policy",null,{"$f":"C17","v":0},0,{"$f":"H17+H18+H19","v":85.97},"for 15 yrs"]
[null,"Pol 3",500000,null,"20 Year Policy",null,{"$f":"C18","v":500000},21.17,{"$f":"H18+H19","v":85.97},"for 20 yrs"]
[null,"Pol 4",1000000,null,"30 Year Policy",null,{"$f":"C19","v":1000000},64.8,{"$f":"H19","v":64.8},"for 30 yrs"]
[]
[null,null,"COVERAGE TERMS FOR SPECIFIC TERMS",null,null,null,null,"Initial Monthly Cost"]
[null,null,"10 Year","15 Year","20 Year","30 Year",null,{"$f":"SUM(H16:H19)","v":85.97}]
[null,null,{"$f":"SUM(C32:C35)","v":1500000},{"$f":"SUM(D32:D35)","v":1500000},{"$f":"SUM(E32:E35)","v":1500000},{"$f":"SUM(F32:F35)","v":1000000}]
[null,null,"Estimated Monthly Income Provided for Specific Years",null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Monthly Income for Specific Years*",null,null,null,null,"* Estimated income achieved when:\n1) investing the full life insurance policy (ies) proceeds; \n2) at an estimated 6% average rate of return; \n3) and, at an estimated average tax rate of 15%."]
[null,null,{"$f":"C23*0.06*0.85/12","v":6375},{"$f":"D23*0.06*0.85/12","v":6375},6375,4250,null,null,null,null,null,null,null,null,null,null,"10 years","15 years","20 years","30 years"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C25","v":6375},{"$f":"D25","v":6375},{"$f":"E25","v":6375},{"$f":"F25","v":4250}]
[null,null,"Protection Password  ","  \"LIFE\"","input cells",null,null,null,null,"12/20/2018mlm/wch",null,null,null,null,null,null,"Monthly Costs per Policy Terms - Locked In**"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I16","v":85.97},{"$f":"I17","v":85.97},{"$f":"I18","v":85.97},{"$f":"I19","v":64.8}]
[null,null,"Graph calculation cells"]
[null,null,"Coverage Needs and Coverage Years",null,null,null,"Total Policy\nFace Amount",null,null,null,null,null,null,"** Policy premiums are determined by current health status, underwriting guidelines, policy face amounts, and policy terms. "]
[null,null,"10 years","15 years","20 years","30 years",null,null,"10 Years",null,null,null,null,"Once the client is qualified, the rates are locked in for the term of the policy as long as premiums are kept current."]
[null,"Pol 1",{"$f":"$C$16","v":0},null,null,null,{"$f":"C32","v":0},null,"15 Years",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J27","v":"12/20/2018mlm/wch"}]
[null,"Pol 2",{"$f":"$C$17","v":0},{"$f":"$C$17","v":0},null,null,{"$f":"C33","v":0},null,"20 Years"]
[null,"Pol 3",{"$f":"$C$18","v":500000},{"$f":"$C$18","v":500000},{"$f":"$C$18","v":500000},null,{"$f":"C34","v":500000},null,"30 Years"]
[null,"Pol 4",{"$f":"$C$19","v":1000000},{"$f":"$C$19","v":1000000},{"$f":"$C$19","v":1000000},{"$f":"$C$19","v":1000000},{"$f":"C35","v":1000000}]

{"sheet":"Life Chart","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,1,28,7],[21,9,21,10],[22,3,23,4],[22,5,23,6],[22,7,23,8],[22,9,23,10],[21,7,21,8],[13,3,13,4],[15,7,15,8],[15,9,15,10],[16,7,16,8],[16,9,16,10],[13,5,13,6],[13,7,13,8],[13,9,13,10],[14,5,14,6],[14,3,14,4],[15,3,15,4],[15,5,15,6],[16,5,16,6],[1,1,1,10],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[12,9,12,10],[3,5,3,6],[20,9,20,10],[19,5,19,6],[19,7,19,8],[17,7,17,8],[17,9,17,10],[18,7,18,8],[18,9,18,10],[20,7,20,8],[18,5,18,6],[17,5,17,6],[29,1,29,9],[24,1,25,3],[26,1,26,3],[9,5,9,6],[9,7,9,8],[10,5,10,6],[10,7,10,8],[10,9,10,10],[14,7,14,8],[14,9,14,10],[11,5,11,6],[11,7,11,8],[11,9,11,10],[12,5,12,6],[12,7,12,8],[19,9,19,10]]}
[]
[null,"LAYERING INSURANCE FOR EFFECTIVENESS (L.I.F.E.)"]
[]
[null,null,null,{"$f":"TODAY()","v":"2019-07-15"},null,null,null,"Age:   ",{"$f":"'Life Chart Worksheet'!C8","v":30},null,null,null,null,"LIFE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Estimated Monthly Income Provided for Specific Years*",null,null,"10 Years","15 Years","20 Years","30 Years",{"$f":"'Life Chart Worksheet'!C9","v":6000},"- initial mo. income needed"]
[null,null,null,null,{"$f":"'Life Chart Worksheet'!C25","v":6375},{"$f":"'Life Chart Worksheet'!D25","v":6375},{"$f":"'Life Chart Worksheet'!E25","v":6375},{"$f":"'Life Chart Worksheet'!F25","v":4250},{"$f":"'Life Chart Worksheet'!C10","v":"1 & 4"},"- dependent children/s ages"]
[null,"Monthly Cost / Policy Term**",null,null,{"$f":"'Life Chart Worksheet'!I16","v":85.97},{"$f":"'Life Chart Worksheet'!I17","v":85.97},{"$f":"'Life Chart Worksheet'!I18","v":85.97},{"$f":"'Life Chart Worksheet'!I19","v":64.8},{"$f":"'Life Chart Worksheet'!C12","v":"next 20 years"},"- the 'critical years'"]
[null,null,null,null,null,null,null,null,{"$f":"'Life Chart Worksheet'!C13","v":"INCOME, MTG"},"- coverage purpose"]
[null,"Once the client is qualified, the rates are locked in for the term of the policy as long as premiums are kept current."]
[null,"* Estimated mo. income achieved by:  1) investing full insurance policy/ies proceeds; 2) at 6% average return; and 3) at 15% average tax rate."]
[null,"** Policy premiums are determined by current health status, underwriting guidelines, policy face amounts, and policy terms. ",null,null,null,null,null,null,null,null,{"$f":"'Life Chart Worksheet'!J27","v":"12/20/2018mlm/wch"}]

{"sheet":"Needs Chart Calculator","index":3,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,2],[31,4,31,5],[1,1,1,4],[3,1,3,4],[5,1,5,4],[12,2,12,3],[17,2,17,3],[20,2,20,3],[26,1,26,4],[29,0,29,1],[30,1,30,4],[2,1,2,2]]}
[]
[null,"INCOME TO INSURANCE CALCULATOR \nPROTECTING YOUR MOST VALUABLE ASSET"]
[null,"     \"How Much is Enough?\"",null,{"$f":"'Life Chart Worksheet'!C7","v":"Mr. Joe Client"}]
[null,"Your Most Valuable Asset: the ability to generate an ongoing income stream for your family."]
[]
[null,"The Sum of Cash Required to Achieve a Specific Monthly Income"]
[]
[null,null,"EXAMPLE: Your Average Annual Income",95000]
[null,null,"Current Monthly Income",{"$f":"D8/12","v":7916.666666666667}]
[null,null,"Earnings Over 20 Year Career",{"$f":"D8*20","v":1900000}]
[null,null,"Earnings Over 30 Year Career",{"$f":"D8*30","v":2850000}]
[null,null,"Earnings Over 45 Year Career",{"$f":"D8*45","v":4275000}]
[null,null,"It makes sense that your ability to generate ongoing income is your most valuable asset."]
[null,null,"Monthly Income Needed",8500]
[null,null,"Average Rate of Return Assumption",0.06]
[null,null,"Average Tax Rate Assumption",0.15]
[null,null,"Existing Life Insurance In-Force \n(and other financial resources)",0]
[]
[null,null,"Total Lump Sum Cash Required",{"$f":"D14*12/$D$15/(1-$D$16)","v":2000000}]
[null,null,"Net Lump Sum Cash Needed (life insurance)\n(in-force subtracted from gross lump sum needed)",{"$f":"D19-D17","v":2000000}]
[null,null,"After identifying the Total Lump Sum Cash required to generate the Monthly Income Needed, existing resources \n(life insurance, savings, or other assets) can be deducted to determine the Net Lump Sum cash needed."]
[null,null,"Annual Savings from your Auto/Home",225.75]
[null,null,"Monthly Amount Saved",{"$f":"D22/12","v":18.8125}]
[null,null,"Monthly Amount You Can Contribute to \nProtect Your Most Valuable Asset",0]
[null,null,"Total Monthly Amount Being Contributed to \nProtect Your Most Valuable Asset",{"$f":"D24+D23","v":18.8125}]
[]
[null,"IMPORTANT DISCLOSURE – The calculations in this chart are for illustration purposes only and are not intended to predict returns or represent actual results. The purpose of this chart is to illustrate a potential monthly income when a lump sum capital remains intact and is NOT reduced. It calculates the approximate amount of lump sum capital or life insurance proceeds needed to provide the surviving spouse / family with a desired amount of after-tax, net monthly income. The illustration assumes the following: 1) a specific amount of insurance proceeds, 2) those proceeds achieving an average hypothetical return, and 3) those proceeds also assuming an average hypothetical tax liability. Specific results will vary depending on the actual initial capital amount invested, the returns earned and tax liabilities. THIS CHART IS FOR ILLUSTRATION PURPOSES ONLY. "]
[null,"For:",{"$f":"'Life Chart Worksheet'!C7:D7","v":"Mr. Joe Client"},{"$f":"TODAY()","v":"2019-07-15"}]
[null,"Agent:","Mark Miletello","858.000.0000\nname@youremail.com"]
["            NOTES:"]
[]
["                                                                     .","ML Approval #201104595  ",null,null,{"$f":"'Life Chart'!K31","v":"12/20/2018mlm/wch"}]
[]
[null,"Worksheet Protection Password = \"LIFE\""]
[null,"Input cells"]